/ Programmer Plus 2007 / Programmer-Plus-2007.iso / Programming / SQL and Data Base / Logic Works ERwin 3.5 / data.1 / ERTMPL32.DLL / RCDATA / 324

< prev

next >

MacOS 8.1

Win98

DOS

view JSON data

view as text

+--------+-------------------------+-------------------------+--------+--------+
|00000000| 43 55 53 54 4f 4d 20 54 | 52 49 47 47 45 52 20 44 |CUSTOM T|RIGGER D|
|00000010| 45 46 41 55 4c 54 20 42 | 4f 44 59 00 63 72 65 61 |EFAULT B|ODY.crea|
|00000020| 74 65 20 74 72 69 67 67 | 65 72 20 25 54 72 69 67 |te trigg|er %Trig|
|00000030| 67 65 72 4e 61 6d 65 20 | 6f 6e 20 25 54 61 62 6c |gerName |on %Tabl|
|00000040| 65 4e 61 6d 65 0d 0a 20 | 20 66 6f 72 20 25 41 63 |eName.. | for %Ac|
|00000050| 74 69 6f 6e 73 28 22 2c | 22 29 0d 0a 20 20 61 73 |tions(",|")..  as|
|00000060| 0d 0a 2f 2a 20 45 52 77 | 69 6e 20 42 75 69 6c 74 |../* ERw|in Built|
|00000070| 69 6e 20 25 44 61 74 65 | 74 69 6d 65 20 2a 2f 0d |in %Date|time */.|
|00000080| 0a 2f 2a 20 25 41 63 74 | 69 6f 6e 73 28 22 2c 22 |./* %Act|ions(","|
|00000090| 29 20 74 72 69 67 67 65 | 72 20 6f 6e 20 25 54 61 |) trigge|r on %Ta|
|000000a0| 62 6c 65 4e 61 6d 65 20 | 2a 2f 0d 0a 2f 2a 20 64 |bleName |*/../* d|
|000000b0| 65 66 61 75 6c 74 20 62 | 6f 64 79 20 66 6f 72 20 |efault b|ody for |
|000000c0| 25 54 72 69 67 67 65 72 | 4e 61 6d 65 20 2a 2f 0d |%Trigger|Name */.|
|000000d0| 0a 62 65 67 69 6e 0d 0a | 20 20 64 65 63 6c 61 72 |.begin..|  declar|
|000000e0| 65 20 20 40 6e 75 6d 72 | 6f 77 73 20 69 6e 74 2c |e  @numr|ows int,|
|000000f0| 0d 0a 20 20 20 20 20 20 | 20 20 20 20 20 40 6e 75 |..      |     @nu|
|00000100| 6c 6c 63 6e 74 20 69 6e | 74 2c 0d 0a 20 20 20 20 |llcnt in|t,..    |
|00000110| 20 20 20 20 20 20 20 40 | 76 61 6c 69 64 63 6e 74 |       @|validcnt|
|00000120| 20 69 6e 74 2c 0d 0a 20 | 20 20 20 20 20 20 20 20 | int,.. |        |
|00000130| 20 20 25 50 4b 44 65 63 | 6c 28 2c 40 69 6e 73 29 |  %PKDec|l(,@ins)|
|00000140| 25 64 65 63 6c 28 62 43 | 6f 6d 6d 61 2c 30 29 25 |%decl(bC|omma,0)%|
|00000150| 46 6f 72 45 61 63 68 41 | 74 74 28 29 20 7b 25 69 |ForEachA|tt() {%i|
|00000160| 66 28 25 41 74 74 49 73 | 50 6b 29 20 7b 25 3d 28 |f(%AttIs|Pk) {%=(|
|00000170| 62 43 6f 6d 6d 61 2c 31 | 29 7d 20 7d 25 69 66 20 |bComma,1|)} }%if |
|00000180| 28 25 3d 3d 28 25 3a 62 | 43 6f 6d 6d 61 2c 31 29 |(%==(%:b|Comma,1)|
|00000190| 29 20 7b 2c 7d 0d 0a 20 | 20 20 20 20 20 20 20 20 |) {,}.. |        |
|000001a0| 20 20 40 65 72 72 6e 6f | 20 20 20 69 6e 74 2c 0d |  @errno|   int,.|
|000001b0| 0a 20 20 20 20 20 20 20 | 20 20 20 20 40 65 72 72 |.       |    @err|
|000001c0| 6d 73 67 20 20 76 61 72 | 63 68 61 72 28 32 35 35 |msg  var|char(255|
|000001d0| 29 0d 0a 0d 0a 20 20 73 | 65 6c 65 63 74 20 40 6e |)....  s|elect @n|
|000001e0| 75 6d 72 6f 77 73 20 3d | 20 40 40 72 6f 77 63 6f |umrows =| @@rowco|
|000001f0| 75 6e 74 0d 0a 25 46 6f | 72 45 61 63 68 43 68 69 |unt..%Fo|rEachChi|
|00000200| 6c 64 52 65 6c 28 29 20 | 7b 0d 0a 20 20 25 52 65 |ldRel() |{..  %Re|
|00000210| 6c 54 65 6d 70 6c 61 74 | 65 0d 0a 7d 0d 0a 25 46 |lTemplat|e..}..%F|
|00000220| 6f 72 45 61 63 68 50 61 | 72 65 6e 74 52 65 6c 28 |orEachPa|rentRel(|
|00000230| 29 20 7b 0d 0a 20 20 25 | 52 65 6c 54 65 6d 70 6c |) {..  %|RelTempl|
|00000240| 61 74 65 0d 0a 7d 0d 0a | 20 20 72 65 74 75 72 6e |ate..}..|  return|
|00000250| 0d 0a 65 72 72 6f 72 3a | 0d 0a 20 20 20 20 72 61 |..error:|..    ra|
|00000260| 69 73 65 72 72 6f 72 20 | 40 65 72 72 6e 6f 20 40 |iserror |@errno @|
|00000270| 65 72 72 6d 73 67 0d 0a | 20 20 20 20 72 6f 6c 6c |errmsg..|    roll|
|00000280| 62 61 63 6b 20 74 72 61 | 6e 73 61 63 74 69 6f 6e |back tra|nsaction|
|00000290| 0d 0a 65 6e 64 0d 0a 67 | 6f 0d 0a 00 30 27       |..end..g|o...0'  |
+--------+-------------------------+-------------------------+--------+--------+